--triggers isnerting invalid with semicolon "...:NEW.ID from dual;"
--otherwise Error code 900, SQL state 42000: ORA-00900: invalid SQL statement in NB (thin driver)


CREATE OR REPLACE TRIGGER  "BI_DEPARTMENT"
  before insert on "DEPARTMENT"
  for each row
begin
    select "DEPARTMENT_SEQ".nextval into :NEW.ID from dual;
end;



CREATE OR REPLACE TRIGGER  "BI_EMPLOYEE"
  before insert on "EMPLOYEE"
  for each row
begin
    select "EMPLOYEE_SEQ".nextval into :NEW.ID from dual;
end;



CREATE OR REPLACE TRIGGER  "BI_REGION"
  before insert on "REGION"
  for each row
begin
    select "REGION_SEQ".nextval into :NEW.ID from dual;
end;

